Blight Predictions for Detroit

In this project, I will attempt to predict whether, for any given parcel in Detroit with a building on it, whether a building on that parcel will be be targetted for demoltion. Potential predictors, downloaded from https://data.detroitmi.gov/, include citations relatated to the building, crime, and complaints concerning the building related to blight. The probject is currently at the data cleaning stage, and I may add some other data to the project. So far, I am using about 3GB of data.

library(tidyverse)
library(sf)
library(ggmap)
library(lwgeom)
#recorded violations associated with blight (e.g. unkempt properties)
blight_violations <- read_csv("./data/Blight_Violations_3_19_2018.csv", 
                              guess_max = 10^6)

Parsed with column specification:
cols(
  .default = col_character(),
  `Ticket ID` = col_integer(),
  `Violator ID` = col_integer(),
  `Violation Street Number` = col_integer(),
  `Hearing Time` = col_time(format = ""),
  `Violation Latitude` = col_double(),
  `Violation Longitude` = col_double()
)
See spec(...) for full column specifications.

|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   1%    1 MB
|=                                                                                         |   1%    1 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   2%    3 MB
|=                                                                                         |   2%    3 MB
|=                                                                                         |   2%    3 MB
|==                                                                                        |   2%    3 MB
|==                                                                                        |   2%    3 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   3%    5 MB
|==                                                                                        |   3%    5 MB
|==                                                                                        |   3%    5 MB
|==                                                                                        |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   4%    6 MB
|===                                                                                       |   4%    6 MB
|===                                                                                       |   4%    7 MB
|===                                                                                       |   4%    7 MB
|===                                                                                       |   4%    7 MB
|===                                                                                       |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    9 MB
|====                                                                                      |   5%    9 MB
|====                                                                                      |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   11 MB
|=====                                                                                     |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   8%   13 MB
|=======                                                                                   |   8%   13 MB
|=======                                                                                   |   8%   13 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|========                                                                                  |   8%   14 MB
|========                                                                                  |   8%   15 MB
|========                                                                                  |   8%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|=========                                                                                 |   9%   16 MB
|=========                                                                                 |   9%   16 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|==========                                                                                |  11%   18 MB
|==========                                                                                |  11%   18 MB
|==========                                                                                |  11%   18 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   20 MB
|==========                                                                                |  11%   20 MB
|==========                                                                                |  11%   20 MB
|==========                                                                                |  12%   20 MB
|==========                                                                                |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   22 MB
|===========                                                                               |  13%   22 MB
|===========                                                                               |  13%   22 MB
|===========                                                                               |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  14%   23 MB
|============                                                                              |  14%   23 MB
|============                                                                              |  14%   24 MB
|============                                                                              |  14%   24 MB
|============                                                                              |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   27 MB
|==============                                                                            |  15%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  17%   28 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|================                                                                          |  17%   29 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  18%   30 MB
|================                                                                          |  18%   30 MB
|================                                                                          |  18%   30 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|=================                                                                         |  18%   31 MB
|=================                                                                         |  18%   31 MB
|=================                                                                         |  18%   32 MB
|=================                                                                         |  18%   32 MB
|=================                                                                         |  18%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   35 MB
|==================                                                                        |  20%   35 MB
|==================                                                                        |  20%   35 MB
|==================                                                                        |  20%   35 MB
|===================                                                                       |  20%   35 MB
|===================                                                                       |  20%   35 MB
|===================                                                                       |  21%   35 MB
|===================                                                                       |  21%   35 MB
|===================                                                                       |  21%   35 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   37 MB
|===================                                                                       |  21%   37 MB
|===================                                                                       |  21%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   39 MB
|====================                                                                      |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  24%   40 MB
|=====================                                                                     |  24%   40 MB
|=====================                                                                     |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  25%   42 MB
|======================                                                                    |  25%   42 MB
|======================                                                                    |  25%   42 MB
|======================                                                                    |  25%   42 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   44 MB
|=======================                                                                   |  25%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|========================                                                                  |  26%   44 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|=========================                                                                 |  27%   46 MB
|=========================                                                                 |  27%   46 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  28%   47 MB
|=========================                                                                 |  28%   47 MB
|=========================                                                                 |  28%   47 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   49 MB
|==========================                                                                |  28%   49 MB
|==========================                                                                |  28%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   50 MB
|==========================                                                                |  29%   50 MB
|==========================                                                                |  29%   50 MB
|==========================                                                                |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   52 MB
|===========================                                                               |  30%   52 MB
|===========================                                                               |  30%   52 MB
|============================                                                              |  30%   52 MB
|============================                                                              |  30%   52 MB
|============================                                                              |  30%   52 MB
|============================                                                              |  31%   52 MB
|============================                                                              |  31%   52 MB
|============================                                                              |  31%   52 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   54 MB
|=============================                                                             |  31%   54 MB
|=============================                                                             |  31%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  34%   57 MB
|===============================                                                           |  34%   57 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  35%   59 MB
|===============================                                                           |  35%   59 MB
|===============================                                                           |  35%   59 MB
|================================                                                          |  35%   59 MB
|================================                                                          |  35%   59 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   61 MB
|================================                                                          |  35%   61 MB
|================================                                                          |  36%   61 MB
|================================                                                          |  36%   61 MB
|================================                                                          |  36%   61 MB
|================================                                                          |  36%   61 MB
|=================================                                                         |  36%   61 MB
|=================================                                                         |  36%   61 MB
|=================================                                                         |  36%   61 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  37%   62 MB
|=================================                                                         |  37%   63 MB
|=================================                                                         |  37%   63 MB
|=================================                                                         |  37%   63 MB
|=================================                                                         |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   65 MB
|==================================                                                        |  38%   65 MB
|==================================                                                        |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   66 MB
|===================================                                                       |  38%   66 MB
|===================================                                                       |  38%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   67 MB
|===================================                                                       |  39%   67 MB
|===================================                                                       |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  41%   69 MB
|=====================================                                                     |  41%   69 MB
|=====================================                                                     |  41%   69 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|=======================================                                                   |  42%   72 MB
|=======================================                                                   |  42%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|========================================                                                  |  43%   74 MB
|========================================                                                  |  44%   74 MB
|========================================                                                  |  44%   74 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   78 MB
|=========================================                                                 |  45%   78 MB
|=========================================                                                 |  46%   78 MB
|=========================================                                                 |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  47%   80 MB
|==========================================                                                |  47%   80 MB
|==========================================                                                |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  48%   81 MB
|===========================================                                               |  48%   81 MB
|===========================================                                               |  48%   81 MB
|===========================================                                               |  48%   82 MB
|===========================================                                               |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   83 MB
|============================================                                              |  48%   83 MB
|============================================                                              |  48%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|==============================================                                            |  50%   85 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  51%   86 MB
|==============================================                                            |  51%   86 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|===============================================                                           |  51%   87 MB
|===============================================                                           |  51%   87 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|================================================                                          |  52%   89 MB
|================================================                                          |  52%   89 MB
|================================================                                          |  52%   89 MB
|================================================                                          |  52%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|=================================================                                         |  53%   91 MB
|=================================================                                         |  53%   91 MB
|=================================================                                         |  53%   91 MB
|=================================================                                         |  54%   91 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   93 MB
|=================================================                                         |  54%   93 MB
|=================================================                                         |  54%   93 MB
|=================================================                                         |  54%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   95 MB
|==================================================                                        |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  57%   96 MB
|===================================================                                       |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  58%   98 MB
|====================================================                                      |  58%   98 MB
|====================================================                                      |  58%   98 MB
|====================================================                                      |  58%   98 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%  100 MB
|=====================================================                                     |  58%  100 MB
|=====================================================                                     |  58%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|======================================================                                    |  59%  100 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|=======================================================                                   |  60%  102 MB
|=======================================================                                   |  60%  102 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  61%  103 MB
|=======================================================                                   |  61%  103 MB
|=======================================================                                   |  61%  103 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|========================================================                                  |  61%  104 MB
|========================================================                                  |  61%  104 MB
|========================================================                                  |  61%  104 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  106 MB
|========================================================                                  |  62%  106 MB
|========================================================                                  |  62%  106 MB
|========================================================                                  |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  108 MB
|=========================================================                                 |  63%  108 MB
|=========================================================                                 |  63%  108 MB
|=========================================================                                 |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  64%  108 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  110 MB
|==========================================================                                |  64%  110 MB
|===========================================================                               |  64%  110 MB
|===========================================================                               |  64%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  112 MB
|============================================================                              |  65%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|=============================================================                             |  67%  113 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  68%  115 MB
|=============================================================                             |  68%  115 MB
|==============================================================                            |  68%  115 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  117 MB
|==============================================================                            |  68%  117 MB
|==============================================================                            |  68%  117 MB
|==============================================================                            |  69%  117 MB
|==============================================================                            |  69%  117 MB
|==============================================================                            |  69%  117 MB
|===============================================================                           |  69%  117 MB
|===============================================================                           |  69%  117 MB
|===============================================================                           |  69%  117 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  119 MB
|===============================================================                           |  70%  119 MB
|===============================================================                           |  70%  119 MB
|===============================================================                           |  70%  119 MB
|===============================================================                           |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  71%  120 MB
|================================================================                          |  71%  120 MB
|================================================================                          |  71%  120 MB
|================================================================                          |  71%  121 MB
|================================================================                          |  71%  121 MB
|================================================================                          |  71%  121 MB
|================================================================                          |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  122 MB
|=================================================================                         |  71%  122 MB
|=================================================================                         |  71%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  123 MB
|=================================================================                         |  72%  123 MB
|=================================================================                         |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  74%  125 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|=====================================================================                     |  75%  128 MB
|=====================================================================                     |  75%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|======================================================================                    |  76%  130 MB
|======================================================================                    |  77%  130 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|=======================================================================                   |  78%  132 MB
|=======================================================================                   |  78%  132 MB
|=======================================================================                   |  78%  132 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  134 MB
|=======================================================================                   |  78%  134 MB
|=======================================================================                   |  78%  134 MB
|=======================================================================                   |  79%  134 MB
|=======================================================================                   |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  136 MB
|========================================================================                  |  80%  136 MB
|========================================================================                  |  80%  136 MB
|========================================================================                  |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  81%  137 MB
|=========================================================================                 |  81%  137 MB
|=========================================================================                 |  81%  137 MB
|=========================================================================                 |  81%  138 MB
|=========================================================================                 |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  139 MB
|==========================================================================                |  81%  139 MB
|==========================================================================                |  81%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  84%  142 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|=============================================================================             |  84%  143 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|==============================================================================            |  85%  145 MB
|==============================================================================            |  85%  145 MB
|==============================================================================            |  85%  145 MB
|==============================================================================            |  85%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|===============================================================================           |  86%  147 MB
|===============================================================================           |  86%  147 MB
|===============================================================================           |  86%  147 MB
|===============================================================================           |  87%  147 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|================================================================================          |  87%  149 MB
|================================================================================          |  88%  149 MB
|================================================================================          |  88%  149 MB
|================================================================================          |  88%  149 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  151 MB
|================================================================================          |  88%  151 MB
|================================================================================          |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  90%  153 MB
|=================================================================================         |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  91%  154 MB
|==================================================================================        |  91%  154 MB
|==================================================================================        |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  156 MB
|===================================================================================       |  91%  156 MB
|===================================================================================       |  91%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|====================================================================================      |  92%  156 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|=====================================================================================     |  93%  158 MB
|=====================================================================================     |  93%  158 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  94%  159 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|======================================================================================    |  94%  160 MB
|======================================================================================    |  94%  160 MB
|======================================================================================    |  94%  160 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  163 MB
|=======================================================================================   |  95%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  164 MB
|=======================================================================================   |  96%  164 MB
|=======================================================================================   |  96%  164 MB
|=======================================================================================   |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  166 MB
|========================================================================================  |  97%  166 MB
|========================================================================================= |  97%  166 MB
|========================================================================================= |  97%  166 MB
|========================================================================================= |  97%  166 MB
|========================================================================================= |  98%  166 MB
|========================================================================================= |  98%  166 MB
|========================================================================================= |  98%  166 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  168 MB
|========================================================================================= |  98%  168 MB
|==========================================================================================|  98%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|===========================================================================================| 100%  170 MB

#read the downloaded file for all the building permits and then filter out the permits for dismantling
dismantle_permits <- read_csv("./data/Building_Permits_3_19_2018.csv", 
                             guess_max = 10^6) %>%
  filter(`Building Permit Type` == "Dismantle")

Parsed with column specification:
cols(
  .default = col_character(),
  `Parcel Size` = col_double(),
  `Parcel Cluster Sector` = col_integer(),
  Stories = col_double(),
  `Parcel Floor Area` = col_integer(),
  `Parcel Ground Area` = col_integer(),
  `Sequence Number` = col_integer()
)
See spec(...) for full column specifications.

  
#the files that contain the crime data
crime_to_12062016 <- 
  read_csv("./data/DPD__All_Crime_Incidents__January_1__2009_-_December_6__2016.csv",
           guess_max = 10^6)

Parsed with column specification:
cols(
  ROWNUM = col_integer(),
  CASEID = col_integer(),
  CRIMEID = col_integer(),
  CRNO = col_character(),
  CATEGORY = col_character(),
  OFFENSEDESCRIPTION = col_character(),
  STATEOFFENSEFILECLASS = col_integer(),
  INCIDENTDATE = col_character(),
  HOUR = col_integer(),
  SCA = col_integer(),
  PRECINCT = col_integer(),
  COUNCIL = col_character(),
  NEIGHBORHOOD = col_character(),
  CENSUSTRACT = col_double(),
  LOCATION = col_character()
)

|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    2 MB
|                                                                                          |   0%    2 MB
|                                                                                          |   1%    2 MB
|                                                                                          |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   2%    4 MB
|=                                                                                         |   2%    4 MB
|=                                                                                         |   2%    4 MB
|=                                                                                         |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   3%    6 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|===                                                                                       |   3%    7 MB
|===                                                                                       |   3%    7 MB
|===                                                                                       |   3%    7 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    9 MB
|===                                                                                       |   3%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|=====                                                                                     |   5%   12 MB
|=====                                                                                     |   5%   12 MB
|=====                                                                                     |   5%   12 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   6%   13 MB
|=====                                                                                     |   6%   13 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   17 MB
|======                                                                                    |   7%   17 MB
|======                                                                                    |   7%   17 MB
|======                                                                                    |   7%   17 MB
|=======                                                                                   |   7%   17 MB
|=======                                                                                   |   7%   17 MB
|=======                                                                                   |   7%   17 MB
|=======                                                                                   |   7%   18 MB
|=======                                                                                   |   7%   18 MB
|=======                                                                                   |   7%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   9%   20 MB
|========                                                                                  |   9%   20 MB
|========                                                                                  |   9%   20 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|=========                                                                                 |   9%   22 MB
|=========                                                                                 |   9%   22 MB
|=========                                                                                 |  10%   22 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  12%   27 MB
|==========                                                                                |  12%   27 MB
|===========                                                                               |  12%   27 MB
|===========                                                                               |  12%   27 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  13%   29 MB
|===========                                                                               |  13%   29 MB
|===========                                                                               |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|=============                                                                             |  14%   32 MB
|=============                                                                             |  14%   32 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   34 MB
|=============                                                                             |  14%   34 MB
|=============                                                                             |  14%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   35 MB
|=============                                                                             |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  16%   36 MB
|==============                                                                            |  16%   36 MB
|==============                                                                            |  16%   36 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|===============                                                                           |  16%   37 MB
|===============                                                                           |  16%   37 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   40 MB
|===============                                                                           |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   41 MB
|================                                                                          |  17%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|=================                                                                         |  18%   42 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  19%   43 MB
|=================                                                                         |  19%   43 MB
|=================                                                                         |  19%   43 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   45 MB
|=================                                                                         |  19%   45 MB
|=================                                                                         |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  20%   45 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|===================                                                                       |  20%   47 MB
|===================                                                                       |  20%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   50 MB
|===================                                                                       |  21%   50 MB
|====================                                                                      |  21%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  23%   52 MB
|=====================                                                                     |  23%   52 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  24%   55 MB
|=====================                                                                     |  24%   55 MB
|=====================                                                                     |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   57 MB
|======================                                                                    |  24%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|=======================                                                                   |  25%   57 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   60 MB
|=======================                                                                   |  26%   60 MB
|=======================                                                                   |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  27%   61 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   65 MB
|=========================                                                                 |  28%   65 MB
|=========================                                                                 |  28%   65 MB
|=========================                                                                 |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   66 MB
|==========================                                                                |  28%   66 MB
|==========================                                                                |  28%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  30%   68 MB
|===========================                                                               |  30%   68 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   70 MB
|===========================                                                               |  30%   70 MB
|===========================                                                               |  30%   70 MB
|===========================                                                               |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|=============================                                                             |  31%   73 MB
|=============================                                                             |  31%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   75 MB
|=============================                                                             |  32%   75 MB
|=============================                                                             |  32%   75 MB
|=============================                                                             |  32%   75 MB
|==============================                                                            |  32%   75 MB
|==============================                                                            |  33%   75 MB
|==============================                                                            |  33%   75 MB
|==============================                                                            |  33%   75 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  34%   77 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   80 MB
|===============================                                                           |  34%   80 MB
|===============================                                                           |  35%   80 MB
|===============================                                                           |  35%   80 MB
|===============================                                                           |  35%   80 MB
|================================                                                          |  35%   80 MB
|================================                                                          |  35%   80 MB
|================================                                                          |  35%   80 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  37%   84 MB
|=================================                                                         |  37%   84 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|==================================                                                        |  37%   85 MB
|==================================                                                        |  37%   85 MB
|==================================                                                        |  37%   85 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   89 MB
|===================================                                                       |  38%   89 MB
|===================================                                                       |  38%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|====================================                                                      |  39%   90 MB
|====================================                                                      |  39%   90 MB
|====================================                                                      |  39%   90 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  40%   91 MB
|====================================                                                      |  40%   91 MB
|====================================                                                      |  40%   91 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|======================================                                                    |  41%   95 MB
|======================================                                                    |  41%   95 MB
|======================================                                                    |  41%   96 MB
|======================================                                                    |  41%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   98 MB
|======================================                                                    |  42%   98 MB
|=======================================                                                   |  42%   98 MB
|=======================================                                                   |  42%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|========================================                                                  |  43%  100 MB
|========================================                                                  |  44%  100 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  103 MB
|========================================                                                  |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  105 MB
|=========================================                                                 |  45%  105 MB
|=========================================                                                 |  45%  105 MB
|=========================================                                                 |  46%  105 MB
|=========================================                                                 |  46%  105 MB
|=========================================                                                 |  46%  105 MB
|==========================================                                                |  46%  105 MB
|==========================================                                                |  46%  105 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  47%  107 MB
|==========================================                                                |  47%  107 MB
|==========================================                                                |  47%  108 MB
|==========================================                                                |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|============================================                                              |  48%  110 MB
|============================================                                              |  48%  110 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  112 MB
|============================================                                              |  48%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  113 MB
|============================================                                              |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|==============================================                                            |  50%  115 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  51%  116 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  118 MB
|==============================================                                            |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|================================================                                          |  52%  120 MB
|================================================                                          |  52%  120 MB
|================================================                                          |  52%  121 MB
|================================================                                          |  52%  121 MB
|================================================                                          |  52%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  123 MB
|================================================                                          |  53%  123 MB
|================================================                                          |  53%  123 MB
|=================================================                                         |  53%  123 MB
|=================================================                                         |  53%  123 MB
|=================================================                                         |  54%  123 MB
|=================================================                                         |  54%  123 MB
|=================================================                                         |  54%  123 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|==================================================                                        |  54%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  128 MB
|==================================================                                        |  55%  128 MB
|==================================================                                        |  55%  128 MB
|==================================================                                        |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  57%  130 MB
|===================================================                                       |  57%  130 MB
|===================================================                                       |  57%  130 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  58%  132 MB
|====================================================                                      |  58%  133 MB
|====================================================                                      |  58%  133 MB
|====================================================                                      |  58%  133 MB
|====================================================                                      |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  135 MB
|=====================================================                                     |  58%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  138 MB
|======================================================                                    |  60%  138 MB
|======================================================                                    |  60%  138 MB
|======================================================                                    |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  61%  139 MB
|=======================================================                                   |  61%  139 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  143 MB
|========================================================                                  |  62%  143 MB
|========================================================                                  |  62%  143 MB
|========================================================                                  |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  144 MB
|=========================================================                                 |  62%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  64%  146 MB
|==========================================================                                |  64%  146 MB
|==========================================================                                |  64%  146 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  148 MB
|==========================================================                                |  64%  148 MB
|==========================================================                                |  64%  148 MB
|==========================================================                                |  64%  148 MB
|===========================================================                               |  64%  148 MB
|===========================================================                               |  64%  148 MB
|===========================================================                               |  64%  148 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  151 MB
|============================================================                              |  65%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  67%  153 MB
|=============================================================                             |  67%  153 MB
|=============================================================                             |  67%  153 MB
|=============================================================                             |  67%  153 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  68%  155 MB
|=============================================================                             |  68%  155 MB
|=============================================================                             |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  158 MB
|==============================================================                            |  69%  158 MB
|==============================================================                            |  69%  158 MB
|==============================================================                            |  69%  158 MB
|==============================================================                            |  69%  158 MB
|===============================================================                           |  69%  158 MB
|===============================================================                           |  69%  158 MB
|===============================================================                           |  69%  158 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  160 MB
|===============================================================                           |  69%  160 MB
|===============================================================                           |  69%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  71%  162 MB
|================================================================                          |  71%  162 MB
|================================================================                          |  71%  162 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|=================================================================                         |  71%  163 MB
|=================================================================                         |  71%  163 MB
|=================================================================                         |  71%  163 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  72%  164 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  167 MB
|==================================================================                        |  72%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|===================================================================                       |  73%  168 MB
|===================================================================                       |  73%  168 MB
|===================================================================                       |  73%  168 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  74%  169 MB
|===================================================================                       |  74%  169 MB
|===================================================================                       |  74%  169 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  171 MB
|===================================================================                       |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  75%  171 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|=====================================================================                     |  75%  173 MB
|=====================================================================                     |  75%  173 MB
|=====================================================================                     |  75%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  176 MB
|=====================================================================                     |  76%  176 MB
|======================================================================                    |  76%  176 MB
|======================================================================                    |  76%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|=======================================================================                   |  78%  178 MB
|=======================================================================                   |  78%  178 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  79%  181 MB
|=======================================================================                   |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  183 MB
|========================================================================                  |  79%  183 MB
|========================================================================                  |  80%  183 MB
|========================================================================                  |  80%  183 MB
|========================================================================                  |  80%  183 MB
|========================================================================                  |  80%  183 MB
|=========================================================================                 |  80%  183 MB
|=========================================================================                 |  80%  183 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  186 MB
|=========================================================================                 |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  82%  187 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|===========================================================================               |  82%  188 MB
|===========================================================================               |  82%  188 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  190 MB
|===========================================================================               |  82%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  191 MB
|===========================================================================               |  83%  191 MB
|===========================================================================               |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|=============================================================================             |  84%  193 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  85%  194 MB
|=============================================================================             |  85%  194 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  196 MB
|=============================================================================             |  85%  196 MB
|=============================================================================             |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|===============================================================================           |  86%  199 MB
|===============================================================================           |  86%  199 MB
|===============================================================================           |  86%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  201 MB
|===============================================================================           |  87%  201 MB
|===============================================================================           |  87%  201 MB
|================================================================================          |  87%  201 MB
|================================================================================          |  87%  201 MB
|================================================================================          |  88%  201 MB
|================================================================================          |  88%  201 MB
|================================================================================          |  88%  201 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|=================================================================================         |  89%  203 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  206 MB
|=================================================================================         |  90%  206 MB
|=================================================================================         |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  91%  208 MB
|==================================================================================        |  91%  208 MB
|==================================================================================        |  91%  208 MB
|==================================================================================        |  91%  208 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  92%  210 MB
|===================================================================================       |  92%  210 MB
|===================================================================================       |  92%  211 MB
|===================================================================================       |  92%  211 MB
|===================================================================================       |  92%  211 MB
|===================================================================================       |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  215 MB
|=====================================================================================     |  93%  215 MB
|=====================================================================================     |  93%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  216 MB
|=====================================================================================     |  94%  216 MB
|=====================================================================================     |  94%  216 MB
|=====================================================================================     |  94%  216 MB
|======================================================================================    |  94%  216 MB
|======================================================================================    |  94%  216 MB
|======================================================================================    |  94%  216 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  95%  217 MB
|======================================================================================    |  95%  217 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  221 MB
|=======================================================================================   |  96%  221 MB
|=======================================================================================   |  96%  221 MB
|=======================================================================================   |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  222 MB
|========================================================================================  |  96%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|==========================================================================================|  98%  226 MB
|==========================================================================================|  98%  226 MB
|==========================================================================================|  99%  226 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  229 MB
|===========================================================================================| 100%  229 MB

crime_12062016_to_03192018 <- 
  read_csv("./data/DPD__All_Crime_Incidents__December_6__2016_-_3_19_2018.csv", 
           guess_max = 10^6)

Parsed with column specification:
cols(
  .default = col_character(),
  `Crime ID` = col_integer(),
  `Day of Week (Sunday is 1)` = col_integer(),
  `Hour of Day` = col_integer(),
  Year = col_integer(),
  `Census Block GEOID` = col_double(),
  `Council District` = col_integer(),
  `Zip Code` = col_integer(),
  Longitude = col_double(),
  Latitude = col_double(),
  uniq = col_integer()
)
See spec(...) for full column specifications.

|=                                                                                                 |   1%
|=                                                                                                 |   1%
|==                                                                                                |   2%
|==                                                                                                |   2%
|==                                                                                                |   2%
|===                                                                                       |   3%    1 MB
|===                                                                                       |   3%    1 MB
|===                                                                                       |   4%    1 MB
|====                                                                                      |   4%    1 MB
|====                                                                                      |   5%    1 MB
|====                                                                                      |   5%    1 MB
|=====                                                                                     |   5%    1 MB
|=====                                                                                     |   6%    1 MB
|======                                                                                    |   6%    2 MB
|======                                                                                    |   7%    2 MB
|======                                                                                    |   7%    2 MB
|=======                                                                                   |   7%    2 MB
|=======                                                                                   |   8%    2 MB
|=======                                                                                   |   8%    2 MB
|========                                                                                  |   9%    2 MB
|========                                                                                  |   9%    2 MB
|========                                                                                  |   9%    3 MB
|=========                                                                                 |  10%    3 MB
|=========                                                                                 |  10%    3 MB
|==========                                                                                |  11%    3 MB
|==========                                                                                |  11%    3 MB
|==========                                                                                |  11%    3 MB
|===========                                                                               |  12%    3 MB
|===========                                                                               |  12%    3 MB
|===========                                                                               |  13%    4 MB
|============                                                                              |  13%    4 MB
|============                                                                              |  13%    4 MB
|=============                                                                             |  14%    4 MB
|=============                                                                             |  14%    4 MB
|=============                                                                             |  15%    4 MB
|==============                                                                            |  15%    4 MB
|==============                                                                            |  15%    4 MB
|==============                                                                            |  16%    5 MB
|===============                                                                           |  16%    5 MB
|===============                                                                           |  17%    5 MB
|===============                                                                           |  17%    5 MB
|================                                                                          |  17%    5 MB
|================                                                                          |  18%    5 MB
|=================                                                                         |  18%    5 MB
|=================                                                                         |  19%    5 MB
|=================                                                                         |  19%    6 MB
|==================                                                                        |  19%    6 MB
|==================                                                                        |  20%    6 MB
|==================                                                                        |  20%    6 MB
|===================                                                                       |  21%    6 MB
|===================                                                                       |  21%    6 MB
|====================                                                                      |  22%    6 MB
|====================                                                                      |  22%    6 MB
|====================                                                                      |  22%    7 MB
|=====================                                                                     |  23%    7 MB
|=====================                                                                     |  23%    7 MB
|=====================                                                                     |  24%    7 MB
|======================                                                                    |  24%    7 MB
|======================                                                                    |  24%    7 MB
|======================                                                                    |  25%    7 MB
|=======================                                                                   |  25%    7 MB
|=======================                                                                   |  26%    8 MB
|========================                                                                  |  26%    8 MB
|========================                                                                  |  26%    8 MB
|========================                                                                  |  27%    8 MB
|=========================                                                                 |  27%    8 MB
|=========================                                                                 |  28%    8 MB
|=========================                                                                 |  28%    8 MB
|==========================                                                                |  28%    8 MB
|==========================                                                                |  29%    9 MB
|===========================                                                               |  29%    9 MB
|===========================                                                               |  30%    9 MB
|===========================                                                               |  30%    9 MB
|============================                                                              |  30%    9 MB
|============================                                                              |  31%    9 MB
|============================                                                              |  31%    9 MB
|=============================                                                             |  32%    9 MB
|=============================                                                             |  32%   10 MB
|==============================                                                            |  32%   10 MB
|==============================                                                            |  33%   10 MB
|==============================                                                            |  33%   10 MB
|===============================                                                           |  34%   10 MB
|===============================                                                           |  34%   10 MB
|===============================                                                           |  35%   10 MB
|================================                                                          |  35%   10 MB
|================================                                                          |  35%   11 MB
|================================                                                          |  36%   11 MB
|=================================                                                         |  36%   11 MB
|=================================                                                         |  37%   11 MB
|==================================                                                        |  37%   11 MB
|==================================                                                        |  37%   11 MB
|==================================                                                        |  38%   11 MB
|===================================                                                       |  38%   11 MB
|===================================                                                       |  39%   12 MB
|===================================                                                       |  39%   12 MB
|====================================                                                      |  39%   12 MB
|====================================                                                      |  40%   12 MB
|=====================================                                                     |  40%   12 MB
|=====================================                                                     |  41%   12 MB
|=====================================                                                     |  41%   12 MB
|======================================                                                    |  41%   12 MB
|======================================                                                    |  42%   13 MB
|======================================                                                    |  42%   13 MB
|=======================================                                                   |  43%   13 MB
|=======================================                                                   |  43%   13 MB
|========================================                                                  |  43%   13 MB
|========================================                                                  |  44%   13 MB
|========================================                                                  |  44%   13 MB
|=========================================                                                 |  45%   13 MB
|=========================================                                                 |  45%   14 MB
|=========================================                                                 |  45%   14 MB
|==========================================                                                |  46%   14 MB
|==========================================                                                |  46%   14 MB
|==========================================                                                |  47%   14 MB
|===========================================                                               |  47%   14 MB
|===========================================                                               |  48%   14 MB
|============================================                                              |  48%   14 MB
|============================================                                              |  48%   15 MB
|============================================                                              |  49%   15 MB
|=============================================                                             |  49%   15 MB
|=============================================                                             |  50%   15 MB
|=============================================                                             |  50%   15 MB
|==============================================                                            |  50%   15 MB
|==============================================                                            |  51%   15 MB
|===============================================                                           |  51%   15 MB
|===============================================                                           |  52%   16 MB
|===============================================                                           |  52%   16 MB
|================================================                                          |  52%   16 MB
|================================================                                          |  53%   16 MB
|================================================                                          |  53%   16 MB
|=================================================                                         |  54%   16 MB
|=================================================                                         |  54%   16 MB
|=================================================                                         |  54%   16 MB
|==================================================                                        |  55%   17 MB
|==================================================                                        |  55%   17 MB
|===================================================                                       |  56%   17 MB
|===================================================                                       |  56%   17 MB
|===================================================                                       |  56%   17 MB
|====================================================                                      |  57%   17 MB
|====================================================                                      |  57%   17 MB
|====================================================                                      |  58%   18 MB
|=====================================================                                     |  58%   18 MB
|=====================================================                                     |  59%   18 MB
|======================================================                                    |  59%   18 MB
|======================================================                                    |  59%   18 MB
|======================================================                                    |  60%   18 MB
|=======================================================                                   |  60%   18 MB
|=======================================================                                   |  61%   18 MB
|=======================================================                                   |  61%   19 MB
|========================================================                                  |  61%   19 MB
|========================================================                                  |  62%   19 MB
|=========================================================                                 |  62%   19 MB
|=========================================================                                 |  63%   19 MB
|=========================================================                                 |  63%   19 MB
|==========================================================                                |  63%   19 MB
|==========================================================                                |  64%   19 MB
|==========================================================                                |  64%   20 MB
|===========================================================                               |  65%   20 MB
|===========================================================                               |  65%   20 MB
|============================================================                              |  65%   20 MB
|============================================================                              |  66%   20 MB
|============================================================                              |  66%   20 MB
|=============================================================                             |  67%   20 MB
|=============================================================                             |  67%   20 MB
|=============================================================                             |  67%   21 MB
|==============================================================                            |  68%   21 MB
|==============================================================                            |  68%   21 MB
|==============================================================                            |  69%   21 MB
|===============================================================                           |  69%   21 MB
|===============================================================                           |  70%   21 MB
|================================================================                          |  70%   21 MB
|================================================================                          |  70%   21 MB
|================================================================                          |  71%   22 MB
|=================================================================                         |  71%   22 MB
|=================================================================                         |  72%   22 MB
|=================================================================                         |  72%   22 MB
|==================================================================                        |  72%   22 MB
|==================================================================                        |  73%   22 MB
|===================================================================                       |  73%   22 MB
|===================================================================                       |  74%   22 MB
|===================================================================                       |  74%   23 MB
|====================================================================                      |  74%   23 MB
|====================================================================                      |  75%   23 MB
|====================================================================                      |  75%   23 MB
|=====================================================================                     |  76%   23 MB
|=====================================================================                     |  76%   23 MB
|=====================================================================                     |  76%   23 MB
|======================================================================                    |  77%   23 MB
|======================================================================                    |  77%   24 MB
|=======================================================================                   |  78%   24 MB
|=======================================================================                   |  78%   24 MB
|=======================================================================                   |  78%   24 MB
|========================================================================                  |  79%   24 MB
|========================================================================                  |  79%   24 MB
|========================================================================                  |  80%   24 MB
|=========================================================================                 |  80%   24 MB
|=========================================================================                 |  80%   25 MB
|==========================================================================                |  81%   25 MB
|==========================================================================                |  81%   25 MB
|==========================================================================                |  82%   25 MB
|===========================================================================               |  82%   25 MB
|===========================================================================               |  83%   25 MB
|===========================================================================               |  83%   25 MB
|============================================================================              |  83%   25 MB
|============================================================================              |  84%   26 MB
|=============================================================================             |  84%   26 MB
|=============================================================================             |  85%   26 MB
|=============================================================================             |  85%   26 MB
|==============================================================================            |  85%   26 MB
|==============================================================================            |  86%   26 MB
|==============================================================================            |  86%   26 MB
|===============================================================================           |  87%   26 MB
|===============================================================================           |  87%   27 MB
|===============================================================================           |  87%   27 MB
|================================================================================          |  88%   27 MB
|================================================================================          |  88%   27 MB
|=================================================================================         |  89%   27 MB
|=================================================================================         |  89%   27 MB
|=================================================================================         |  89%   27 MB
|==================================================================================        |  90%   27 MB
|==================================================================================        |  90%   28 MB
|==================================================================================        |  91%   28 MB
|===================================================================================       |  91%   28 MB
|===================================================================================       |  91%   28 MB
|====================================================================================      |  92%   28 MB
|====================================================================================      |  92%   28 MB
|====================================================================================      |  93%   28 MB
|=====================================================================================     |  93%   28 MB
|=====================================================================================     |  94%   29 MB
|=====================================================================================     |  94%   29 MB
|======================================================================================    |  94%   29 MB
|======================================================================================    |  95%   29 MB
|=======================================================================================   |  95%   29 MB
|=======================================================================================   |  96%   29 MB
|=======================================================================================   |  96%   29 MB
|========================================================================================  |  96%   29 MB
|========================================================================================  |  97%   30 MB
|========================================================================================  |  97%   30 MB
|========================================================================================= |  98%   30 MB
|========================================================================================= |  98%   30 MB
|==========================================================================================|  98%   30 MB
|==========================================================================================|  99%   30 MB
|==========================================================================================|  99%   30 MB
|===========================================================================================| 100%   30 MB

#the 311 system
improve_detroit_issues <- read_csv("./data/Improve_Detroit_Issues_3_19_2018.csv", 
                                   guess_max = 10^6)

Parsed with column specification:
cols(
  `Ticket ID` = col_integer(),
  `Ticket Status` = col_character(),
  `Issue Type` = col_character(),
  `Issue Description` = col_character(),
  `Created At` = col_character(),
  `Acknowledged At` = col_character(),
  `Closed At` = col_character(),
  `Reopened At` = col_character(),
  `Updated At` = col_character(),
  `Days to Close` = col_double(),
  `Report Method` = col_character(),
  `Priority Code` = col_integer(),
  `Canonical Issue Id` = col_integer(),
  `Web Link` = col_character(),
  Address = col_character(),
  Neighborhood = col_character(),
  `Council District` = col_integer(),
  Location = col_character()
)

|==========                                                                                |  11%    4 MB
|===========                                                                               |  12%    4 MB
|===========                                                                               |  12%    4 MB
|============                                                                              |  13%    5 MB
|============                                                                              |  13%    5 MB
|============                                                                              |  14%    5 MB
|=============                                                                             |  14%    5 MB
|=============                                                                             |  15%    5 MB
|==============                                                                            |  15%    5 MB
|==============                                                                            |  16%    6 MB
|===============                                                                           |  16%    6 MB
|===============                                                                           |  17%    6 MB
|===============                                                                           |  17%    6 MB
|================                                                                          |  17%    6 MB
|================                                                                          |  18%    7 MB
|=================                                                                         |  18%    7 MB
|=================                                                                         |  19%    7 MB
|==================                                                                        |  19%    7 MB
|==================                                                                        |  20%    7 MB
|==================                                                                        |  20%    7 MB
|===================                                                                       |  21%    8 MB
|===================                                                                       |  21%    8 MB
|====================                                                                      |  22%    8 MB
|====================                                                                      |  22%    8 MB
|=====================                                                                     |  23%    8 MB
|=====================                                                                     |  23%    8 MB
|=====================                                                                     |  24%    9 MB
|======================                                                                    |  24%    9 MB
|======================                                                                    |  25%    9 MB
|=======================                                                                   |  25%    9 MB
|=======================                                                                   |  25%    9 MB
|========================                                                                  |  26%   10 MB
|========================                                                                  |  26%   10 MB
|========================                                                                  |  27%   10 MB
|=========================                                                                 |  27%   10 MB
|=========================                                                                 |  28%   10 MB
|==========================                                                                |  28%   10 MB
|==========================                                                                |  29%   11 MB
|===========================                                                               |  29%   11 MB
|===========================                                                               |  30%   11 MB
|===========================                                                               |  30%   11 MB
|============================                                                              |  31%   11 MB
|============================                                                              |  31%   12 MB
|=============================                                                             |  32%   12 MB
|=============================                                                             |  32%   12 MB
|==============================                                                            |  33%   12 MB
|==============================                                                            |  33%   12 MB
|==============================                                                            |  33%   12 MB
|===============================                                                           |  34%   13 MB
|===============================                                                           |  34%   13 MB
|================================                                                          |  35%   13 MB
|================================                                                          |  35%   13 MB
|=================================                                                         |  36%   13 MB
|=================================                                                         |  36%   14 MB
|=================================                                                         |  37%   14 MB
|==================================                                                        |  37%   14 MB
|==================================                                                        |  38%   14 MB
|===================================                                                       |  38%   14 MB
|===================================                                                       |  39%   14 MB
|====================================                                                      |  39%   15 MB
|====================================                                                      |  40%   15 MB
|====================================                                                      |  40%   15 MB
|=====================================                                                     |  41%   15 MB
|=====================================                                                     |  41%   15 MB
|======================================                                                    |  41%   15 MB
|======================================                                                    |  42%   16 MB
|=======================================                                                   |  42%   16 MB
|=======================================                                                   |  43%   16 MB
|=======================================                                                   |  43%   16 MB
|========================================                                                  |  44%   16 MB
|========================================                                                  |  44%   17 MB
|=========================================                                                 |  45%   17 MB
|=========================================                                                 |  45%   17 MB
|=========================================                                                 |  46%   17 MB
|==========================================                                                |  46%   17 MB
|==========================================                                                |  47%   17 MB
|===========================================                                               |  47%   18 MB
|===========================================                                               |  48%   18 MB
|============================================                                              |  48%   18 MB
|============================================                                              |  49%   18 MB
|=============================================                                             |  49%   18 MB
|=============================================                                             |  49%   19 MB
|=============================================                                             |  50%   19 MB
|==============================================                                            |  50%   19 MB
|==============================================                                            |  51%   19 MB
|===============================================                                           |  51%   19 MB
|===============================================                                           |  52%   19 MB
|================================================                                          |  52%   20 MB
|================================================                                          |  53%   20 MB
|================================================                                          |  53%   20 MB
|=================================================                                         |  54%   20 MB
|=================================================                                         |  54%   20 MB
|==================================================                                        |  55%   21 MB
|==================================================                                        |  55%   21 MB
|===================================================                                       |  56%   21 MB
|===================================================                                       |  56%   21 MB
|===================================================                                       |  57%   21 MB
|====================================================                                      |  57%   21 MB
|====================================================                                      |  58%   22 MB
|=====================================================                                     |  58%   22 MB
|=====================================================                                     |  59%   22 MB
|======================================================                                    |  59%   22 MB
|======================================================                                    |  59%   22 MB
|======================================================                                    |  60%   22 MB
|=======================================================                                   |  60%   23 MB
|=======================================================                                   |  61%   23 MB
|========================================================                                  |  61%   23 MB
|========================================================                                  |  62%   23 MB
|=========================================================                                 |  62%   23 MB
|=========================================================                                 |  63%   24 MB
|==========================================================                                |  63%   24 MB
|==========================================================                                |  64%   24 MB
|==========================================================                                |  64%   24 MB
|===========================================================                               |  65%   24 MB
|===========================================================                               |  65%   24 MB
|============================================================                              |  66%   25 MB
|============================================================                              |  66%   25 MB
|=============================================================                             |  67%   25 MB
|=============================================================                             |  67%   25 MB
|=============================================================                             |  68%   25 MB
|==============================================================                            |  68%   26 MB
|==============================================================                            |  69%   26 MB
|===============================================================                           |  69%   26 MB
|===============================================================                           |  69%   26 MB
|================================================================                          |  70%   26 MB
|================================================================                          |  70%   27 MB
|=================================================================                         |  71%   27 MB
|=================================================================                         |  71%   27 MB
|=================================================================                         |  72%   27 MB
|==================================================================                        |  72%   27 MB
|==================================================================                        |  73%   27 MB
|===================================================================                       |  73%   28 MB
|===================================================================                       |  74%   28 MB
|===================================================================                       |  74%   28 MB
|====================================================================                      |  75%   28 MB
|====================================================================                      |  75%   28 MB
|=====================================================================                     |  76%   28 MB
|=====================================================================                     |  76%   29 MB
|======================================================================                    |  76%   29 MB
|======================================================================                    |  77%   29 MB
|======================================================================                    |  77%   29 MB
|=======================================================================                   |  78%   29 MB
|=======================================================================                   |  78%   29 MB
|========================================================================                  |  79%   30 MB
|========================================================================                  |  79%   30 MB
|========================================================================                  |  80%   30 MB
|=========================================================================                 |  80%   30 MB
|=========================================================================                 |  81%   30 MB
|==========================================================================                |  81%   31 MB
|==========================================================================                |  81%   31 MB
|==========================================================================                |  82%   31 MB
|===========================================================================               |  82%   31 MB
|===========================================================================               |  83%   31 MB
|============================================================================              |  83%   31 MB
|============================================================================              |  84%   32 MB
|=============================================================================             |  84%   32 MB
|=============================================================================             |  85%   32 MB
|=============================================================================             |  85%   32 MB
|==============================================================================            |  86%   32 MB
|==============================================================================            |  86%   32 MB
|===============================================================================           |  86%   33 MB
|===============================================================================           |  87%   33 MB
|===============================================================================           |  87%   33 MB
|================================================================================          |  88%   33 MB
|================================================================================          |  88%   33 MB
|=================================================================================         |  89%   33 MB
|=================================================================================         |  89%   34 MB
|==================================================================================        |  90%   34 MB
|==================================================================================        |  90%   34 MB
|==================================================================================        |  91%   34 MB
|===================================================================================       |  91%   34 MB
|===================================================================================       |  92%   35 MB
|====================================================================================      |  92%   35 MB
|====================================================================================      |  93%   35 MB
|=====================================================================================     |  93%   35 MB
|=====================================================================================     |  93%   35 MB
|=====================================================================================     |  94%   35 MB
|======================================================================================    |  94%   36 MB
|======================================================================================    |  95%   36 MB
|=======================================================================================   |  95%   36 MB
|=======================================================================================   |  96%   36 MB
|========================================================================================  |  96%   36 MB
|========================================================================================  |  97%   37 MB
|========================================================================================  |  97%   37 MB
|========================================================================================= |  98%   37 MB
|========================================================================================= |  98%   37 MB
|==========================================================================================|  99%   37 MB
|==========================================================================================|  99%   37 MB
|===========================================================================================| 100%   38 MB

#the shapefile representing Detroit parcels, read into 
parcel_sf <- st_read("./data/Parcel Map")

Reading layer `geo_export_ad366f11-96e5-4f0f-9d17-7a6ae8e48482' from data source `/Users/stuartbarnum/Desktop/R files/Detroit-Demolitions/data/Parcel Map' using driver `ESRI Shapefile'
Simple feature collection with 382051 features and 37 fields
geometry type:  MULTIPOLYGON
dimension:      XY
bbox:           xmin: -83.28763 ymin: 42.25539 xmax: -82.91066 ymax: 42.45011
epsg (SRID):    4326
proj4string:    +proj=longlat +ellps=WGS84 +no_defs

#writeLines(c("parcel_sf", " ", colnames(parcel_sf)), "parcel_sf.txt")

For all of the downloaded datasets other than the parcels dataset, we extract extract the usable latutude and longitude values and then use this information to form simple features (sf) objects. Rows with obviously incorrect values, or values that would represent positions well outside Detroit, are filtered out, together with rows for which the latitude or longitude data is missing.

#function for converting the position (character) column into a column of points in the simple features (sf) framework.
add_sf_point <- function(df, column) {
  
  #extract the latitude and longitude from the string column that contains both. With the parentheses
  #located from the end of the strings, it is possible to use the the same function for all five of 
  #the datasets for which we need to extract this information.
  latitude <- str_sub(df[[column]], 
                      stringi::stri_locate_last_fixed(df[[column]], "(")[,2] + 1,
                      stringi::stri_locate_last_fixed(df[[column]], ",")[,1] - 1)
  longitude <- str_sub(df[[column]], 
                       stringi::stri_locate_last_fixed(df[[column]], ", ")[,2] + 1, 
                       stringi::stri_locate_last_fixed(df[[column]], ")")[,1] - 1)
  
  #add the latititude and and longitude to a copy of the dataframe, filter out the NAs from
  #these results, and then convert convert to sf, with point positions indicated in the
  #geometry column
  mutated <- df %>% mutate(extracted_lat = as.double(latitude),
                      extracted_lon = as.double(longitude))
  
  #remove rows with NAs for latitude or longitude, or with values well outside of Detroit
  filtered <- mutated %>%
    filter(!is.na(extracted_lat) & !is.na(extracted_lon)) %>%
    filter(41 < extracted_lat & extracted_lat < 44 & -85 < extracted_lon & extracted_lon < -81)
    
  #create a dataframe from the items that have been filtered out
  result_coord_na <- setdiff(mutated, filtered)
  
  #create sf objects from the rows with usable latitude and longitude information
  result_sf <- st_as_sf(filtered, coords = c("extracted_lon", "extracted_lat"), crs = 4326)
    
  return(list(result_sf, result_coord_na))
}
#apply the function to the five datasets for which the data was not loaded as a simple features dataframe, thus producing a list of two dataframes for each of the datasets, the first element of the list a simple features data frame and the second element a dataframe with the instances for which it was not possible to convert to simple features
blight_violations_split <- add_sf_point(blight_violations, "Violation Location")
dismantle_permits_split <- add_sf_point(dismantle_permits, "Permit Location")
crime_to_12062016_split <- add_sf_point(crime_to_12062016, "LOCATION")
crime_12062016_to_03192018_split <- add_sf_point(crime_12062016_to_03192018, "Location")
improve_detroit_issues_split <- add_sf_point(improve_detroit_issues, "Location")

We now consider the data for which we do not yet have position data, and complete the information as well as we reasonably can, using the Google api and a function, geocode_pause, that handles some of api’s quirks.

#the portino of the downloaded blight citations data, for which we do not have
blight_vio_na <- blight_violations_split[[2]]
#remove the rows for which geocoding is not likely to prodoce reliable results
useful <- blight_vio_na %>% filter(!is.na(`Violation Street Name`), 
                                   `Violation Street Number` > 0, 
                                   !is.na(`Violation Zip Code`))
#create a column of addresses to be used in geocoding
useful <- useful %>% 
  mutate(complete_address = paste(`Violation Street Number`, " ", `Violation Street Name`, ", ",
                                  "Detroit, Michigan", " ", `Violation Zip Code`, sep = ""))
#function makes a maximum 6 attempts to geocode the given address using the Google API, with a pause of 1 second between attempts. We will use the function for the other datasets as well.
geocode_pause <- function(address) {
  for (index in 1:6) {
    Sys.sleep(1)
    location <- ggmap::geocode(address)
    if (!is.na(location$lon)) {
      return(location)
    }
  }
}

#apply geocode_pause to each of the elements of the complete_addresse column and place the result in a new column, in which each entry is a data frame 
useful <- useful %>% mutate(location = map(complete_address, geocode_pause))

#save to disc, to avoid avoid the need to geocode these addresses again when we rerun the analysis
write_rds(useful, "./data/blight_violations_geocodes.rds")

The geocoding has returned a data frame for each of the addresses. We thus need to unpack the elements of the location column, each of which is a data frame.

#read blight_violations_geocodes as a tibble
blight_violations_geocodes <- read_rds("./data/blight_violations_geocodes.rds")
#function for removing the instances for which geocoding failed (for which the value in the location column is NULLL). We will use this function for all of the geocoded data frames.
remove_null_locations <- function(df) {
  #identify the rows for which the value in the location column is NULL
  null_rows <- list()
  for (index in 1:nrow(df)) {
    if (is.null(df$location[[index]])) {
      null_rows <- c(null_rows, index)
    }
  }
  #remove the rows for which the value of the location column is NULL
  df <- df[-as.integer(null_rows),]
}
blight_violations_geocodes <- remove_null_locations(blight_violations_geocodes)
#With blight_violations_geocodes a tibble, we can apply tidyr::unnest(), which will place the latitude and longitude in columns labelled "lat" and "lon".
blight_violations_geocodes <- blight_violations_geocodes %>% unnest(location)
#fill in the `Violation Latitute` and `Violation Longitude` data frames, which alread exist in the blight_violations data frame
blight_violations_geocodes <- blight_violations_geocodes %>%
  mutate(`Violation Latitude` = lat,
         `Violation Longitude` = lon)
#cut out some columns that have been added
blight_violations_geocodes <- blight_violations_geocodes %>% 
  select(-extracted_lat, -extracted_lon, -complete_address)
#put the position information into a simple features format (which will remove the "lat" and "lon" columns)
blight_violations_geocodes_sf <- st_as_sf(blight_violations_geocodes, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)
#combine the results with the previously generated sf data
blight_violations_sf <- rbind(blight_violations_split[[1]], blight_violations_geocodes_sf)
rm(blight_vio_na, blight_violations, blight_violations_geocodes, 
   blight_violations_geocodes_sf, blight_violations_split, useful)

#the dismantle permits for which position data (latitude and longitude) is missing
dismantle_permits_split_na <- dismantle_permits_split[[2]]
#remove the last two columns, which were not contained in the original dismantle_permits datastet
dismantle_permits_split_na <- dismantle_permits_split_na %>% 
  select(-extracted_lat, -extracted_lon)

#geocode the items in dismantle_permits_split_na, using the address column and the function geocode_pause, which makes a maximum of six attempts for each item. The result is list of dataframes in the location column.
dismantle_permits_split_geocode <- dismantle_permits_split_na %>%
  mutate(location = map(str_c(`Site Address`, ", Detroit, Michigan"), geocode_pause))

#write the results of the geocoding to disk, to avoid having to repeat the geocoding when rerunning the analysis.
write_rds(dismantle_permits_split_geocode, "./data/dismantle_permits_geocodes.rds")

rm(dismantle_permits_split_na)

#load the geocoded data frame into R
dismantle_permits_split_geocode <- read_rds("./data/dismantle_permits_geocodes.rds")
#use the remove_null_locations() to remove the rows for which geocoding failed and then parse the information  in the dataframes in the location column into two new columns, lat and lan
dismantle_permits_split_geocode <- 
  remove_null_locations(dismantle_permits_split_geocode) %>%
  unnest(location)
#convert to a simple features (sf) data frame, using the latititudes and longitudes
dismantle_permits_geocode_sf <- st_as_sf(dismantle_permits_split_geocode, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)
#append this simple features dataframe to the dataframe for which we already had usable positions
dismantle_permits_sf <- rbind(dismantle_permits_split[[1]], dismantle_permits_geocode_sf)
rm(dismantle_permits_split_geocode, dismantle_permits_geocode_sf, dismantle_permits, dismantle_permits_split, dismantle_permits_split_na)

We now fill-in the missing position information for the dataset for crimes up to 12-06-2016

#return to the older crime data
crime_to_12062016_leftovers <- crime_to_12062016_split[[2]]
#cut out the addresses that begin with "00"
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  filter(str_sub(LOCATION, 1, 2) != "00")
#filter out some obviously useless addresses, with few characters before the first "("
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  filter(!str_locate(LOCATION, "\\(")[,1] %in% 1:13)
#remove the two columns that were added earlier
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  select(-extracted_lat, -extracted_lon)
#create a column for use in geocoding
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  mutate(extracted_address = str_c(str_sub(LOCATION, 1, 
                                           str_locate(LOCATION, "\\(")[,1] - 2),
                                                      ", Detroit, Michigan"))

#geocode the elements of extracted_address, using the function geocode_pause
crime_to_12062016_leftovers_geocode <- crime_to_12062016_leftovers %>% 
  mutate(location = map(extracted_address, geocode_pause))

#save the results, to avoid having to geocode again when rerunning the analysis
write_rds(crime_to_12062016_leftovers_geocode, "./data/crime_to_12062016_leftovers_geocode.rds")

crime_to_12062016_leftovers_geocode <- read_rds("./data/crime_to_12062016_leftovers_geocode.rds")
#cut out the column we used for geocoding
crime_to_12062016_leftovers_geocode <- 
  crime_to_12062016_leftovers_geocode %>% select(-extracted_address)
  
#cut out of the geocode failures and put the location information into the columns lat and lon
crime_to_12062016_leftovers_geocode <- 
  remove_null_locations(crime_to_12062016_leftovers_geocode) %>%
  unnest(location)
#create a simple features (sf) object, using the latititudes and longitudes
crime_to_12062016_leftovers_sf <- st_as_sf(crime_to_12062016_leftovers_geocode, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)
#append this simple features dataframe to the dataframe for which we already had locations
crime_to_12062016_sf <- rbind(crime_to_12062016_split[[1]], crime_to_12062016_leftovers_sf)
rm(crime_to_12062016, crime_to_12062016_leftovers_geocode, crime_to_12062016_leftovers_sf, crime_to_12062016_leftovers, crime_to_12062016_split)

#consider the examples in the recent crime data for which the conversion to sf didn't work, remove the two columns that we have added, and create and address column for geocoding
crime_12062016_to_03192018_leftovers <- crime_12062016_to_03192018_split[[2]] %>%
  select(-extracted_lat, -extracted_lon) %>%
  mutate(extracted_address = str_c(`Incident Address`, ", Detroit, Michigan"))

crime_12062016_to_03192018_geocode <- crime_12062016_to_03192018_leftovers %>% 
  mutate(location = map(extracted_address, geocode_pause))

write_rds(crime_12062016_to_03192018_geocode, "./data/crime_12062016_to_03192018_geocode.rds")

crime_12062016_to_03192018_geocode <- read_rds("./data/crime_12062016_to_03192018_geocode.rds") %>%
  select(-extracted_address)
#remove the rows for which the value of location is NULL and then unnest the remaining locations
crime_12062016_to_03192018_geocode <- 
  remove_null_locations(crime_12062016_to_03192018_geocode) %>%
  unnest(location)
#convert the dataframe to a simple features set
crime_12062016_to_03192018_sf <- st_as_sf(crime_12062016_to_03192018_geocode, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)  
#combine the geocoded data with the sf dataframe created earlier
crime_12062016_to_03192018 <- rbind(crime_12062016_to_03192018_split[[1]], crime_12062016_to_03192018_sf)
rm(crime_12062016_to_03192018_split, crime_12062016_to_03192018_geocode, crime_12062016_to_03192018_leftovers, crime_12062016_to_03192018_sf)

#geocode the one item in the Improve Detroit Issues data for which the given coordinates were obviously incorrect, and then convert to an sf object. If geocoding fails, run this bit again
improve_detroit_issues_leftover_sf <- improve_detroit_issues_split[[2]] %>%
  select(-extracted_lat, -extracted_lon) %>%
  mutate(location = map(Address, geocode_pause)) %>%
  unnest(location) %>% 
  st_as_sf(coords = c("lon", "lat"), crs = 4326)  

Error in eval(lhs, parent, parent) : 
  object 'improve_detroit_issues_split' not found

We begin the assignment of labels to the buidings: blighted or not blighted. Buildings will be represented by parcels that have or have had buildings on them, whether by being so represented as in the parcels_sf data frame as including structures or in the dismantle permits dataframe as having had a dismante permit associated with it, thus suggesting that there was a building on the parcel.

We will use parcel numbers to refer to the parcels. This works because parcelnum column contains no repeats over different rows (see below, in which duplicate_parcel_numbers_in_parcel_data has zero rows).

#As per above, following returns an empty data frame
duplicate_parcel_numbers_in_parcel_data <- 
  parcel_sf %>%
  group_by(parcelnum) %>% 
  mutate(n = n()) %>%
  ungroup() %>% 
  filter(n > 1)
duplicate_parcel_numbers_in_parcel_data

Simple feature collection with 78 features and 38 fields
geometry type:  MULTIPOLYGON
dimension:      XY
bbox:           xmin: -83.17034 ymin: 42.32219 xmax: -83.0055 ymax: 42.4416
epsg (SRID):    4326
proj4string:    +proj=longlat +ellps=WGS84 +no_defs

rm(duplicate_parcel_numbers_in_parcel_data)

The dismantle permits data, however, may seem less clean than the parcel_sf, as it contains repetitions of the parcel numbers that correspond to different addresses that would refer, in some cases, to distinct locations. (It also indicates that a few individual locatations, identified with addresses, had more than one associated dismantle permit. This need not be problematic—a permit could expire before the work is carried out, or there could be more than one structure on a parcel.) These repetitions are in duplicate_parcel_numbers_over_distinct_addresses, which contains 260 rows. I should also note that, in most of these cases with duplicate parcel numbers (and addresses indicating different locations), the recorded latitude and longitude are identical. We can thus infer that some of this location information is incorrect.

dup_par_num_in_dismantle_data <-
  dismantle_permits_sf %>%
  group_by(`Parcel Number`) %>% 
  mutate(n = n()) %>%
  ungroup() %>% 
  filter(n > 1) %>%
  select(`Parcel Number`, `Site Address`)
as.data.frame(dup_par_num_in_dismantle_data)

rm(dup_par_num_in_dismantle_data)
#parcel numbers in the dismantle permits data that are distributed over disinct addresseses
dup_par_num_over_distinct_addresses <- 
  dismantle_permits_sf %>%
  group_by(`Parcel Number`) %>%
  mutate(parcel_number_occurances = n()) %>%
  ungroup() %>%
  filter(parcel_number_occurances > 1) %>%
  select(`Parcel Number`, `Site Address`, parcel_number_occurances) %>%
  group_by(`Parcel Number`, `Site Address`) %>%
  mutate(m = n()) %>%
  filter(m < parcel_number_occurances) %>%
  arrange(`Parcel Number`)
as.data.frame(dup_par_num_over_distinct_addresses)

rm(dup_par_num_over_distinct_addresses)

Some of repeats of the parcel numbers would seem to correspond to the some location (with the addresses recorded somewhat differently), while others would not. The number of rows in question is relatively small (272), so I will ignore the issue for now. (I will eventually either remove this data are attempt to attache the correct location information.)

#note that the following removes rows with duplicate parcels
#duplicate_parcel_numbers %>% distinct(parcelnum, .keep_all = TRUE)

parcel_join_sf_parcel_first <- 
  full_join(parcel_sf %>% select(parcelnum),
            dismantle_permits_sf %>% as.data.frame() %>% select(`Parcel Number`),
            c("parcelnum" = "Parcel Number")) %>%
  arrange(`Parcel Number`)

parcel_join_sf_dismantle_first <-
  full_join(dismantle_permits_sf %>% select(`Parcel Number`), 
            parcel_sf %>% as.data.frame() %>% select(parcelnum),
            c("Parcel Number" = "parcelnum")) %>%
  arrange(`Parcel Number`)

st_crs(parcel_sf)
st_crs(dismantle_permits_sf)

#Both of these yield an EPSG of 4326. Nethereless, the follow step seems necessary.

st_crs(dismantle_permits_sf) <- st_crs(parcel_sf)

temp <- st_join(dismantle_permits_sf, parcel_sf, join = st_within)
  
temp2 <- temp %>% filter(`Parcel Number` != parcelnum)

temp2 <- temp2 %>% select(`Parcel Number`, parcelnum, `Site Address`, address)


#note that objectid in parcel_sf has no NA values, and that objectid is a key in parcel_sf
parcel_sf %>% as.data.frame() %>% filter(is.na(objectid))
parcel_sf %>% count(objectid) %>% filter(n > 1)

#note that `Permit Number` is a also a key, for dismantle_permits_sf
dismantle_permits_sf %>% as.data.frame() %>% filter(is.na(`Permit Number`))
dismantle_permits_sf %>% count(`Permit Number`) %>% filter(n > 1)

#with the above in mind, we examine the NA values for these columns in our full join, beginning with objectid in parcel_sf. The idea is that any NA value for objectid in parcel_join would correspond to a parcel in the dismantle permits dataset that is either not reflected in the parcels dataset or for which there is a flaw in the data.
parcel_join %>% filter(is.na(objectid))

dismantle_permits_sf %>% filter(`Parcel Number` == "22108512.")

#dismantled_structures <- initial_join %>% filter(!is.na(`Permit Number`))

parcel_sf %>% filter(parcelnum == "22108512.")

parcel_tmp <- blight_violations_sf[c(1, 2),]

st_distance(parcel_tmp)

m_list <- mapply(st_distance, blight_violations_sf$geometry[1], fred$geometry)

dismantle_permits_sf %>% as.data.frame() %>% filter(is.na(`Parcel Number`))

temp4 <- st_distance(parcel_sf[195099,], 
            blight_violations_sf[22233:22255,])

st_crs(blight_violations_sf) <- st_crs(parcel_sf)

plot(blight_violations_sf, max.plot = 1)

Maps:

library(ggmap)

ggplot(blight_violations_sf %>% select(geometry)) +
  geom_sf() + 
  geom_density2d(data = blight_violations_sf %>% select(geometry))


ggplot(data=xy.sf) +
    geom_sf() +
    geom_density2d(data=xy.sf, aes(x=x,y=y,colour=..level..))


detroit_gg <- get_map("Detroit", maptype = "toner-lite",
                      zoom = 11)

ggmap(detroit_gg)